BF has a couple of numeric settings where you really need a description as well as just the number. You can use one of BF"s library information functions (search under Describe...), and these give you the most detailed explanation, but if you want the number and a tiny explanation in the same cell, you can use these pre-prepared conditional formats. Currently conditional formats are implemented for:
- The ProjMode variable ie Cash/Accruals
- The Periods variable ie Quartertly/Annually in advance/arrears etc
Note that you can also use a one of BF"s standard Data Validations, which has the advantage of presenting the use with a menu of options (because its a Validation Format), but you have to use ExInt() to extract the result for use in a formulae, because it"s text. |